-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	4.1.22-community-nt


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema MySqlProviders
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ MySqlProviders;
USE MySqlProviders;

--
-- Table structure for table `MySqlProviders`.`aspnet_applications`
--

DROP TABLE IF EXISTS `aspnet_applications`;
CREATE TABLE `aspnet_applications` (
  `ApplicationName` varchar(255) collate latin1_general_ci NOT NULL default '',
  `ApplicationId` int(10) unsigned NOT NULL auto_increment,
  `Description` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`ApplicationId`),
  KEY `Index_2` (`ApplicationName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `MySqlProviders`.`aspnet_applications`
--

/*!40000 ALTER TABLE `aspnet_applications` DISABLE KEYS */;
INSERT INTO `aspnet_applications` (`ApplicationName`,`ApplicationId`,`Description`) VALUES 
 ('MySqlProviders',1,'');
/*!40000 ALTER TABLE `aspnet_applications` ENABLE KEYS */;


--
-- Table structure for table `MySqlProviders`.`aspnet_membership`
--

DROP TABLE IF EXISTS `aspnet_membership`;
CREATE TABLE `aspnet_membership` (
  `ApplicationId` int(10) unsigned NOT NULL default '0',
  `UserId` int(10) unsigned NOT NULL default '0',
  `Password` varchar(128) collate latin1_general_ci NOT NULL default '',
  `PasswordFormat` tinyint(1) unsigned NOT NULL default '0',
  `PasswordSalt` varchar(128) collate latin1_general_ci NOT NULL default '',
  `MobilePin` varchar(16) collate latin1_general_ci default NULL,
  `Email` varchar(255) collate latin1_general_ci default NULL,
  `PasswordQuestion` varchar(255) collate latin1_general_ci default NULL,
  `PasswordAnswer` varchar(255) collate latin1_general_ci default NULL,
  `IsApproved` tinyint(1) unsigned default NULL,
  `IsLockedOut` tinyint(1) unsigned default NULL,
  `CreateDate` datetime default NULL,
  `LastLoginDate` datetime default NULL,
  `LastPasswordChangedDate` datetime default NULL,
  `LastLockedOutDate` datetime default NULL,
  `FailedPasswordAttemptCount` int(10) unsigned default NULL,
  `FailedPasswordAttemptWindowStart` datetime default NULL,
  `FailedPasswordAnswerAttemptCount` int(10) unsigned default NULL,
  `FailedPasswordAnswerAttemptWindowStart` datetime default NULL,
  `Comment` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`UserId`),
  KEY `Index_2` (`ApplicationId`,`Email`),
  CONSTRAINT `FK_aspnet_membership_1` FOREIGN KEY (`UserId`) REFERENCES `aspnet_users` (`UserId`),
  CONSTRAINT `FK_aspnet_membership_2` FOREIGN KEY (`ApplicationId`) REFERENCES `aspnet_applications` (`ApplicationId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='InnoDB free: 10240 kB';

--
-- Table structure for table `MySqlProviders`.`aspnet_paths`
--

DROP TABLE IF EXISTS `aspnet_paths`;
CREATE TABLE `aspnet_paths` (
  `ApplicationId` int(10) unsigned NOT NULL default '0',
  `PathId` int(10) unsigned NOT NULL auto_increment,
  `Path` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`PathId`),
  KEY `Index_2` (`ApplicationId`,`Path`),
  CONSTRAINT `FK_aspnet_paths_1` FOREIGN KEY (`ApplicationId`) REFERENCES `aspnet_applications` (`ApplicationId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 10240 kB';

--
-- Table structure for table `MySqlProviders`.`aspnet_personalizationallusers`
--

DROP TABLE IF EXISTS `aspnet_personalizationallusers`;
CREATE TABLE `aspnet_personalizationallusers` (
  `PathId` int(10) unsigned NOT NULL default '0',
  `PageSettings` longblob NOT NULL,
  `LastUpdatedDate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`PathId`),
  CONSTRAINT `FK_aspnet_personalizationallusers_1` FOREIGN KEY (`PathId`) REFERENCES `aspnet_paths` (`PathId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 10240 kB';

--
-- Table structure for table `MySqlProviders`.`aspnet_personalizationperuser`
--

DROP TABLE IF EXISTS `aspnet_personalizationperuser`;
CREATE TABLE `aspnet_personalizationperuser` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `PathId` int(10) unsigned NOT NULL default '0',
  `UserId` int(10) unsigned NOT NULL default '0',
  `PageSettings` longblob NOT NULL,
  `LastUpdatedDate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ID`),
  KEY `FK_aspnet_PersonalizationPerUser_1` (`UserId`),
  KEY `Index_3` (`PathId`,`UserId`),
  CONSTRAINT `FK_aspnet_PersonalizationPerUser_1` FOREIGN KEY (`UserId`) REFERENCES `aspnet_users` (`UserId`),
  CONSTRAINT `FK_aspnet_PersonalizationPerUser_2` FOREIGN KEY (`PathId`) REFERENCES `aspnet_paths` (`PathId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 10240 kB; (`UserId`) REFER `MySqlProviders/aspnet_users`';

--
-- Table structure for table `MySqlProviders`.`aspnet_profile`
--

DROP TABLE IF EXISTS `aspnet_profile`;
CREATE TABLE `aspnet_profile` (
  `UserId` int(10) unsigned NOT NULL default '0',
  `PropertyNames` text collate latin1_general_ci NOT NULL,
  `propertyValuesString` text collate latin1_general_ci NOT NULL,
  `PropertyValuesBinary` longblob NOT NULL,
  `LastUpdatedDate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`UserId`),
  CONSTRAINT `FK_aspnet_profile_1` FOREIGN KEY (`UserId`) REFERENCES `aspnet_users` (`UserId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `MySqlProviders`.`aspnet_roles`
--

DROP TABLE IF EXISTS `aspnet_roles`;
CREATE TABLE `aspnet_roles` (
  `RoleId` int(10) unsigned NOT NULL auto_increment,
  `ApplicationId` int(10) unsigned NOT NULL default '0',
  `RoleName` varchar(255) NOT NULL default '',
  `Description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`RoleId`),
  KEY `Index_2` (`ApplicationId`,`RoleName`),
  CONSTRAINT `FK_aspnet_roles_1` FOREIGN KEY (`ApplicationId`) REFERENCES `aspnet_applications` (`ApplicationId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 10240 kB';

--
-- Table structure for table `MySqlProviders`.`aspnet_users`
--

DROP TABLE IF EXISTS `aspnet_users`;
CREATE TABLE `aspnet_users` (
  `UserId` int(10) unsigned NOT NULL auto_increment,
  `UserName` varchar(255) collate latin1_general_ci NOT NULL default '',
  `ApplicationId` int(10) unsigned NOT NULL default '0',
  `MobileAlias` varchar(16) collate latin1_general_ci default NULL,
  `IsAnonymous` tinyint(1) unsigned NOT NULL default '0',
  `LastActivityDate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`UserId`),
  KEY `Index_3` (`ApplicationId`,`LastActivityDate`),
  KEY `Index_2` (`ApplicationId`,`UserName`),
  CONSTRAINT `FK_aspnet_users_1` FOREIGN KEY (`ApplicationId`) REFERENCES `aspnet_applications` (`ApplicationId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Table structure for table `MySqlProviders`.`aspnet_usersinroles`
--

DROP TABLE IF EXISTS `aspnet_usersinroles`;
CREATE TABLE `aspnet_usersinroles` (
  `UserId` int(10) unsigned NOT NULL default '0',
  `RoleId` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`UserId`,`RoleId`),
  KEY `Index_2` (`RoleId`),
  CONSTRAINT `FK_aspnet_UsersInRoles_1` FOREIGN KEY (`UserId`) REFERENCES `aspnet_users` (`UserId`),
  CONSTRAINT `FK_aspnet_usersinroles_2` FOREIGN KEY (`RoleId`) REFERENCES `aspnet_roles` (`RoleId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 10240 kB;  InnoDB free: 8192 ';

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
